<?php
//require_once '../include/dbcon.php';
function generateid()
{
$DB_host = "localhost";
$DB_user = "root";
$DB_pass = "";
$DB_name = "achievers";
 
	try
	{
		$DBcon = new PDO("mysql:host={$DB_host};dbname={$DB_name}",$DB_user,$DB_pass);	
		$DBcon->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
	}
	catch(PDOException $e)
	{
		echo "ERROR : ".$e->getMessage();
	}
$sql = $DBcon->prepare("select sn from stall_details ORDER BY SN DESC LIMIT 1");
$sql->execute() ;
if($sql->rowcount() >0)
{
$row = $sql->FETCH(PDO::FETCH_ASSOC) ;
$id = $row['sn'] ;
}
else
{
$id = 0 ;
}
$t=time();
$newid = $id + 1 ;
$prfix = 'ANMARKT'.$t.'_0' ;
$newuserid = $prfix.$newid ;
//$pwd = $newid.'xchangex' ;
return $newuserid ;
//return $pwd ;	
}
?>